GATE PYQ

ISRO CSE 2013

Q61.
Consider the following relational schema: Suppliers (sid:integer, sname:string, saddress:string) Parts (pid:integer, pname:string, pcolor:string) Catalog (sid:integer, pid:integer, pcost:real) What is the result of the following query? (SELECT Catalog.pid from Suppliers, Catalog WHERE Suppliers.sid = Catalog.sid) MINUS (SELECT Catalog.pid from Suppliers, Catalog WHERE Suppliers.sname <> 'Sachin' and Suppliers.sid = Catalog.sid)

Q62.
Which of the following is the highest isolation level in transaction management?

Q63.
Which algorithm is used to shape the bursty traffic into a fixed rate traffic by averaging the data rate?

Q64.
The protocol data unit for the transport layer in the internet stack is

Q65.
In a three stage counter, using RS flip flops what will be the value of the counter after giving 9 pulses to its input ? Assume that the value of counter before giving any pulses is 1 :